import pymysql

conncect = pymysql.Connect(
    host='localhost',
    port=3306,
    user='root',
    password='DRsXT5ZJ6Oi55LPQ',
    db='xiaoyuan',
    charset='utf8'
)

cursor = conncect.cursor()

sql_users = "TRUNCATE cmf_mask_users"
cursor.execute(sql_users)

sql_tmp = "TRUNCATE cmf_mask_tmp"
cursor.execute(sql_tmp)

sql_pay = "TRUNCATE cmf_mask_pay"
cursor.execute(sql_pay)

sql_delivery = "TRUNCATE cmf_mask_delivery"
cursor.execute(sql_delivery)

sql_bill = "TRUNCATE cmf_mask_bill"
cursor.execute(sql_bill)
